<?php

class SiteController extends Controller
{
	/**
	 * Declares class-based actions.
	 */
	public function actions()
	{
            //echo '???';die;
		return array(
			// captcha action renders the CAPTCHA image displayed on the contact page
			'captcha'=>array(
				'class'=>'CCaptchaAction',
				'backColor'=>0xFFFFFF,
			),
			// page action renders "static" pages stored under 'protected/views/site/pages'
			// They can be accessed via: index.php?r=site/page&view=FileName
			'page'=>array(
				'class'=>'CViewAction',
			),
		);
	}

	/**
	 * This is the default 'index' action that is invoked
	 * when an action is not explicitly requested by users.
	 */
	public function actionIndex()
	{
		// renders the view file 'protected/views/site/index.php'
		// using the default layout 'protected/views/layouts/main.php'
		$this->render('index');
	}

	/**
	 * This is the action to handle external exceptions.
	 */
	public function actionError()
	{
		if($error=Yii::app()->errorHandler->error)
		{
			if(Yii::app()->request->isAjaxRequest)
				echo $error['message'];
			else
				$this->render('error', $error);
		}
	}

	/**
	 * Displays the contact page
	 */
	public function actionContact()
	{
            //echo 'GiangLV welcome Yii';die;
		$model=new ContactForm;               // var_dump($model);die;
		if(isset($_POST['ContactForm']))
		{
			$model->attributes=$_POST['ContactForm'];
			if($model->validate())
			{
				$name='=?UTF-8?B?'.base64_encode($model->name).'?=';
				$subject='=?UTF-8?B?'.base64_encode($model->subject).'?=';
				$headers="From: $name <{$model->email}>\r\n".
					"Reply-To: {$model->email}\r\n".
					"MIME-Version: 1.0\r\n".
					"Content-Type: text/plain; charset=UTF-8";

				mail(Yii::app()->params['adminEmail'],$subject,$model->body,$headers);
				Yii::app()->user->setFlash('contact','Thank you for contacting us. We will respond to you as soon as possible.');
				$this->refresh();
			}
		}
		$this->render('contact',array('model'=>$model));
              
                
	}

	/**
	 * Displays the login page
	 */
	public function actionLogin()
	{
		$model=new LoginForm;

		// if it is ajax validation request
		if(isset($_POST['ajax']) && $_POST['ajax']==='login-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}

		// collect user input data
		if(isset($_POST['LoginForm']))
		{
			$model->attributes=$_POST['LoginForm'];
			// validate user input and redirect to the previous page if valid
			if($model->validate() && $model->login())
				$this->redirect(Yii::app()->user->returnUrl);
		}
		// display the login form
		$this->render('login',array('model'=>$model));
	}

	/**
	 * Logs out the current user and redirect to homepage.
	 */
	public function actionLogout()
	{
		Yii::app()->user->logout();
		$this->redirect(Yii::app()->homeUrl);
	}
        
        /* display member */
        public function actionMember()
        {
            
            $model =new MemberForm;
            if(isset($_POST['MemberForm']))
            {
                $model->attributes = $_POST['MemberForm'];
                
                $sql = "insert into member (username,password) values ('$model->name','$model->password')";
                //echo $sql;die;
                //$parameters = array("user"=>,"pass"=>$model->password);
                $connection = Yii::app()->db;
                $command=$connection->createCommand($sql);
                $command->execute();

               // Yii::app()->db->createCommand($sql)->execute();
            }
               $rows = Yii::app()->db->createCommand()->select('*')->from('member')->queryAll();
           ///$list = array()
            //Note: parameter model in array
            $this->render('member',array('model'=>$model,'list'=>$rows));
        }
        public function actionAjaxmember()
        {
           // sleep(4);
            $arr = array();
            $arr = $_REQUEST['MemberForm'];
            $name = $arr['name'];
            $pass = md5($arr['password']);
             $sql = "insert into member (username,password) values ('$name','$pass')";
                //echo $sql;die;
                //$parameters = array("user"=>,"pass"=>$model->password);
                $connection = Yii::app()->db;
                $command=$connection->createCommand($sql);
                $command->execute();
                //get data from db
                $rows = Yii::app()->db->createCommand()->select('*')->from('member')->queryAll();
            $html = '';
            $html .= '<table>';
             $html .= '<tr><td>Num</td><td>Name</td><td>Edit</td><td>Delete</td></tr>';
             $num = 1;
                foreach ($rows as $value) {
                    $del = $value['id'];
                    $html .= '<tr><td>'.$num.'</td><td>'.$value['username'].'</td>'
                            .'<td><a href="#" onclick="editmember('.$value['id'].');">Edit</a></td>'
                            .'<td><a href="'.Yii::app()->createAbsoluteUrl("site/memberdelete/$del").'">Delete</a></td>'
                            .'</tr>';
                    $num ++;
                }
            $html .= '</table>'; 
           // echo json_encode($html);
            echo $html;
        }
        public function actionMemberdelete()
        {
           $id = Yii::app()->request->getQuery('id');
           $command = Yii::app()->db->createCommand();

            $sql='DELETE FROM member WHERE id=:id';
            $params = array(
                "id" => $id,
               // "id" => $id
            );
            $command->setText($sql)->execute($params);
            $this->redirect(array('site/member'));
        }
}